CRMQuery object

Use the CRMQuery Object to enter and execute SQL statements against a known system database. This can be either the system database or an external database that's known and connected to Sage CRM.

You can perform more powerful queries with CRMQuery than with the CRMRecord object. You can use it to execute SQL statements that return results, for example, SELECT statements or statements that don't return results, for example, DELETE statements.

Preceding code:

var Query;
Query = CRM.CreateQueryObj('Select * from tablename', 'databasename');

• CRMQuery methods
• CRMQuery properties